SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 162514 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 162514 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046227,77544,1037829,1024005,33979,802149,1037005,903162,518549,982293,987786,613600,761897,16534,567886,181722,419665,77636,38401,1037832,584287,110255,51161,418016,980930,600701,932625,313422,43313,480354,718981,1032288,600042,1040395,895686,832814,569143,925915,971747,905874,1028721,830327,120321,933679,552023,436169,23212,385407,430712,844686,608554,901107,792320,661357,252152,292912,894242,104379,788379,425024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 162514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 162514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001291s ]