SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416400 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416400 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102219,439726,884154,676707,466212,565945,751977,433047,527620,912191,888397,84357,910957,832619,954163,986918,957159,162322,467880,379467,1022796,274061,101304,92712,183160,525986,757588,793514,318313,1029710,957943,375964,470701,730034,825806,1016670,347525,444554,206427,1046193,447744,119881,760412,515216,316403,139823,335618,914746,277691,653127,14495,884836,730724,247536,943927,543415,425461,518526,310035,891983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]