SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.009350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397041 LIMIT 1 [ RunTime:0.003156s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397041 [ RunTime:0.012202s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583301,468136,294543,164462,827458,622990,743006,215754,548142,232329,1035661,182356,643788,456320,883581,164271,187567,245819,1016519,850087,85879,273296,1047443,115824,302111,426697,308330,740090,465414,581696,876103,1039512,601539,191560,31331,530726,214892,805576,668402,461625,375794,809974,588847,758006,453588,174305,2023,1002035,757298,431723,352081,284626,239887,480553,497012,737252,838347,730914,68098,550817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001930s ]