SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460940 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460940 [ RunTime:0.002522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348808,316784,438494,985012,241914,796889,790887,109049,496085,23717,284367,234882,554947,127558,209860,672828,635852,431349,96366,337836,358511,217519,373315,818085,49275,491950,842416,248913,358704,664411,789195,372569,697285,881982,29897,430009,136888,695684,878277,423342,386556,906865,223878,611464,314521,733557,660468,353144,467108,882990,450705,704764,179279,123553,393937,562817,387648,393724,72701,411619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]