SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001889s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 386024 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 386024 [ RunTime:0.002257s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108098,112751,625448,456782,644056,770036,293656,964671,148903,243520,858896,834268,352009,474107,852509,331213,449828,258562,550813,643884,563400,835759,14916,613074,595687,673707,120656,99420,518695,98332,1006972,881800,284322,699097,383759,651168,253305,198169,309410,79770,252280,299339,661653,524818,629144,554584,609626,976774,108453,945873,38277,1025847,308192,872553,993552,103667,798873,915186,435682,343409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 386024 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 386024 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]