SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001472s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409102 LIMIT 1 [ RunTime:0.001918s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409102 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (735913,355426,289730,701411,740128,925042,945197,858346,198103,338466,695511,819649,1046104,364873,314143,318046,690607,477816,695611,21132,904206,181953,87276,532295,91351,394399,937067,48741,787301,515570,858323,681444,473233,555723,122242,492510,164311,623686,621835,130962,300595,89690,404537,1006251,458458,703141,1024675,4668,201880,942306,418300,449855,660637,733011,425993,99098,150932,965104,396128,941847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001675s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]