SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203365 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203365 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830534,584263,866452,981800,387528,1010259,441167,460336,679000,106942,949776,165456,909143,920132,872293,736866,939560,81450,402995,738910,711767,379710,428986,701171,123687,212846,18277,567028,88258,525104,116724,127495,523399,14885,492549,933026,805694,32891,480449,606874,38874,224594,953644,497004,321383,430890,10502,54528,559842,400097,94765,145366,140352,250110,907804,604489,132496,885670,868304,337045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203365 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203365 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]