SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017328 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017328 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440579,786024,236557,718102,348321,584855,381636,622740,432835,680838,687617,880788,551567,1005767,641546,443336,637351,523170,418457,121588,861082,481149,632603,354160,151387,330342,851580,1040105,924175,974769,1013359,497955,456808,380562,27803,76715,659986,1002676,565923,344709,100286,929200,1031491,246968,359185,981920,101239,627761,607354,447558,106053,420959,497044,643486,477538,907602,37382,120400,71713,1027722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]