SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50462 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50462 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698348,571476,567205,105189,790495,1040865,205520,262260,742077,535482,91647,973322,375784,1013830,694198,396803,1016587,498673,201057,578537,416004,261887,105907,399125,459817,978385,78802,528690,988158,226460,501617,26614,133022,6830,689679,399596,394251,863816,38660,285166,271239,781712,160707,478515,277173,184049,694423,677449,502564,481210,226828,537943,1047337,485227,841468,76382,38437,884452,157512,567820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50462 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50462 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002469s ]