SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418072 LIMIT 1 [ RunTime:0.002165s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418072 [ RunTime:0.004709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010411,280436,733750,349073,564152,187091,661646,892623,370781,946446,300397,10554,420431,757174,613111,97919,555019,990416,1012693,383608,257559,873605,411591,71958,304879,683521,254026,188903,235966,106709,240816,352157,812112,754559,820377,465414,720548,82221,72534,799577,662450,674505,207262,327068,29092,673781,379784,473936,651819,690129,602420,988513,473397,310634,297413,167976,694920,329656,576706,566213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]