SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498699 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498699 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (597708,92146,302817,131621,518812,694773,835968,183979,574998,931319,127364,75176,61874,549420,61627,268325,616916,496143,419274,743863,757405,729069,485603,29390,402220,86670,969629,137171,981682,197593,817785,951740,994113,979305,122174,904735,198892,410615,659805,966657,368714,692204,855973,227992,86156,795560,605446,271753,862386,1018329,598034,806519,684836,631983,482579,153647,434884,881649,401749,331492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]