SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 143882 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 143882 [ RunTime:0.002853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588075,758263,184336,304097,61259,377841,986527,705712,359208,456206,790004,4693,220906,895910,867720,444173,746489,463902,377401,902928,351033,901842,674025,401499,250209,760995,1036007,750430,1011737,784410,696949,619156,637933,745715,780652,755135,331119,392791,61722,242936,421210,228141,790024,99998,709103,558490,800908,584422,99397,455320,1047140,579329,480216,1015824,1004009,879890,630103,1012602,897068,792224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 143882 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 143882 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]