SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456218 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456218 [ RunTime:0.004925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486582,249674,425057,579588,836808,308644,643997,989682,437004,476378,495256,805580,25949,1018032,170571,771741,319338,615274,697753,321170,596462,81544,121065,491752,611886,462611,187489,794402,10864,44193,329645,419501,30278,27296,868800,684143,772141,285206,477798,642394,489423,367409,317788,621920,1044812,344943,452812,443212,905816,533638,59004,801205,103701,967815,848515,944994,762029,283841,593648,879164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]