SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 62017 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 62017 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525852,125479,128574,216529,493581,889956,391230,651864,398917,18307,295740,325013,622500,401784,1011395,1011302,568112,737130,967525,274047,605830,367586,843549,295452,848597,401022,260270,84728,333280,472405,442877,1023641,359637,719883,257444,898634,907635,921953,498713,702408,183096,671711,742162,283285,734979,475571,267828,306910,24828,367330,220380,328495,230007,301841,914940,55222,193175,872394,192596,15166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 62017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 62017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000758s ]