SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002470s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901541 LIMIT 1 [ RunTime:0.001780s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901541 [ RunTime:0.004435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613173,328008,41746,677657,557610,330728,1031847,511119,980921,874697,348933,1012902,206894,66862,665428,30474,767928,442233,460013,83906,281170,208093,865636,188406,783904,944428,179231,627819,1023907,398283,678055,799687,327927,529390,757190,866835,467442,384877,864474,562317,378749,418352,482140,772091,361754,365992,687092,951868,876740,1007243,625833,57769,287712,221863,831518,60331,312321,552607,1017556,25329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000665s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]