SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 595030 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 595030 [ RunTime:0.002594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407356,199889,66010,884037,327662,341244,288943,475983,617168,623111,171469,671051,389688,1020439,730309,90278,994560,817349,197826,70937,1024507,498380,300146,695810,326818,71318,404116,208228,330873,202795,532680,672623,511261,384055,190825,846154,992408,557293,1021334,421347,125061,908851,1004382,832028,98379,398043,516995,270436,500814,252936,509459,160383,377685,901714,94577,567177,28919,100103,482164,128039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 595030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 595030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]