SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405077 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405077 [ RunTime:0.004717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938870,559930,569620,867129,70686,268917,716699,1013796,851170,883976,1021321,95077,773724,980301,826032,544140,703051,802294,811458,592205,732639,88874,728231,535367,35585,124447,416136,74663,331372,542709,187513,540214,899685,3002,591418,877324,900597,814690,397729,50118,319624,132596,960735,604626,113132,957831,65410,890320,772686,761175,511177,354411,396786,535925,686084,846820,515041,406724,571400,145613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405077 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405077 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002614s ]