SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 956839 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 956839 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894983,272750,62571,1010718,667669,626165,693303,273362,1022528,594159,1029286,270425,949924,104061,650819,116493,734441,497348,1038492,981776,525116,728171,363564,532181,556641,319535,529899,31989,893911,785186,687368,353768,240999,343992,138795,845205,178014,973111,19094,605187,467333,989803,201206,2830,662449,25924,186054,680769,1019228,311284,460205,897609,742037,60277,397700,173403,467877,138919,938541,414064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 956839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 956839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]