SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456251 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456251 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151070,733778,907477,49451,1036717,135306,161950,235895,615863,111924,956780,341807,343765,112303,374654,893595,78040,179886,952672,561149,525602,734103,561254,809886,327247,832734,410907,335336,678408,20903,405393,571520,34455,349426,234969,763785,52116,990164,877664,746735,119466,165901,868536,47393,531677,480827,496421,550831,407640,1003706,773213,929094,522891,439894,960644,153125,892308,586467,469705,317126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]