SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034679 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034679 [ RunTime:0.003544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047380,455731,744702,758866,574911,805518,679246,65755,166801,918593,196014,813406,739694,60154,317062,234239,236679,358138,19612,689766,467280,776495,256973,204467,120582,125238,5262,290254,800990,216445,69539,1044501,383898,971849,895671,759499,36692,760353,508513,485806,775767,616056,797418,550848,769683,772415,598915,897272,627997,357856,886183,1713,401247,775720,611754,199553,255974,557422,43713,35941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001765s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034679 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034679 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]