SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026180 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026180 [ RunTime:0.002542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475410,743790,488806,646260,799351,225798,511810,254693,429323,476050,319590,242202,534437,22335,35077,172720,120238,351151,743963,579454,154296,939166,1020105,866457,767176,59163,894682,840219,953389,396135,740315,699465,544173,147576,662716,975301,526385,129157,455045,1003429,855279,79487,299831,720952,841962,819181,317907,108209,972249,1047321,948643,366946,1010619,329990,731831,951286,675221,426729,645165,261830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001764s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]