SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 652018 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 652018 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56190,543637,69658,846680,273643,736789,273986,740780,241331,621789,904240,125187,898256,176467,906286,828347,812433,693002,979530,153719,925466,427182,330632,47022,409594,335415,716796,1033158,215175,98460,1008823,243344,114865,578542,430984,677123,783000,1023042,804145,698714,595418,707801,730392,586103,23822,761557,885162,658106,913510,151886,687244,689369,342672,589900,325216,136617,624823,398317,26878,399851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 652018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 652018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]