SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 732243 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 732243 [ RunTime:0.002547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202438,406574,1027655,692595,223843,754551,851962,553709,444580,1024567,1019777,423373,663678,931754,654432,231847,797469,921855,600747,536053,516338,785784,877802,706907,268083,1013140,596439,535045,421302,228200,985486,528308,1019189,256247,968606,280617,42785,496757,191222,42491,330994,648578,696761,520150,597208,244251,142076,737136,173651,854013,366435,57508,567790,915331,828609,106955,816302,1041722,1028370,728944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 732243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 732243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]