SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282416 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282416 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427125,59684,602474,788173,765865,731687,1017884,710334,536990,222162,505485,985524,50298,64029,134009,855391,311071,40667,1033821,132859,920524,394392,781136,759426,239512,909709,23116,545654,319797,636445,921480,984203,976761,195360,1030331,104509,904283,70780,103610,851908,300789,552425,712379,772226,147624,684009,763487,409379,789209,333334,842864,495726,915193,1018838,663326,8344,567291,954036,893832,769070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001747s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]