SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 168380 LIMIT 1 [ RunTime:0.000688s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 168380 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618157,955746,604311,767154,542203,527444,706054,634438,486261,735403,502676,36136,893306,834630,869701,25574,596822,118830,818052,22239,401866,721171,337307,716640,276101,220482,454000,743186,131920,169780,150891,111128,194962,330428,521254,991406,979327,562860,307847,958767,584347,938731,515868,169676,742929,1029314,370880,478883,277909,456270,121441,466888,241766,164684,436431,450869,312015,318134,132470,982581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 168380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 168380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]