SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031540 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031540 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401399,947094,858962,803574,210712,38616,346420,826181,120602,153774,756581,284762,399794,629954,716290,124561,130576,965034,1014187,626197,769029,812434,591049,815252,517710,1004062,431364,162594,843362,917878,779490,620362,684191,657331,695970,768668,870814,1011003,910787,192326,736963,499098,781111,674108,79385,336958,279134,127904,803535,975615,813180,162790,513703,719304,221100,637369,63909,946998,511329,226449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]