SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410580 LIMIT 1 [ RunTime:0.001586s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410580 [ RunTime:0.003453s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027121,31728,963570,767925,79173,708562,233863,172362,839275,738248,850835,154383,808770,148130,826044,382901,983389,627324,621754,752149,548332,195046,837955,571902,544635,280413,631573,147336,537951,161349,195214,693092,260678,1048681,226820,605749,203423,648168,264106,276194,350026,874932,33870,684606,461427,551731,401925,783854,137342,684277,823175,60228,305624,275607,655930,44362,886244,175338,300583,644564) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]