SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599040 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599040 [ RunTime:0.001566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488935,793197,80996,591801,201719,1008897,578405,374745,122471,474689,431786,797568,186296,193189,392932,748724,487264,152229,669603,746559,855904,589076,1024996,936225,590044,540958,594880,828195,943948,236332,821259,212955,98624,74652,984064,366810,224727,714743,676942,893300,905629,505519,185269,736583,425600,877118,604406,776614,328063,559816,12943,638824,110058,919315,228184,542867,328381,326170,773420,364833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]