SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513419 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513419 [ RunTime:0.002258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (854438,829004,68328,284953,599089,119494,482004,906956,360917,89876,728374,816646,259176,835817,805439,571823,955329,300468,232818,927960,171854,920164,955323,836866,285996,40322,102812,922166,491090,652916,525801,150016,297812,289317,823470,410989,326937,227053,95401,649723,507028,104299,234044,307342,1042942,838445,827794,845954,357411,585477,703460,821352,8457,442835,133682,40201,983268,583453,139133,383714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001681s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]