SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589906 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589906 [ RunTime:0.002508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340387,426623,138495,854875,638920,335680,53013,482761,13439,880443,546793,630962,561998,996124,486475,647730,103895,157366,286454,835561,717966,807068,1042661,838075,883122,1011404,552488,411963,193668,145555,83099,110234,186634,1045312,405339,373356,851004,648601,727835,439042,813375,681077,540668,99317,443424,1046512,1032523,868340,418154,497298,632878,59543,982745,605759,609972,485519,146790,777263,477690,889620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000641s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]