SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001810 LIMIT 1 [ RunTime:0.001972s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001810 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106588,280515,460586,1005002,1035345,986674,460109,840035,10376,350641,474541,953194,900395,549373,412456,588060,182708,296719,390004,219180,670481,631056,954058,793509,38766,361542,334487,659119,893987,401493,377709,112486,96300,556887,17405,820373,50238,990585,596735,533109,861491,46903,678689,280782,244450,923754,581605,560334,824881,779235,813048,806064,38632,522547,1001712,359456,101609,71727,246,432541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002899s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]