SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 323910 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 323910 [ RunTime:0.004393s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558241,855452,1031520,964212,397530,255167,311647,329055,855899,484019,312441,709514,696436,1048457,214850,125780,672259,93149,409853,917727,463062,932818,750963,457935,323960,995621,425042,719636,926769,680568,754739,601276,148498,478969,1013254,100564,62961,992474,656694,215561,304647,379656,446659,64653,124291,886205,425114,43980,725496,115688,467222,583134,951537,339752,994069,450149,143249,827134,471154,671283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 323910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 323910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]