SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563310 LIMIT 1 [ RunTime:0.002043s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563310 [ RunTime:0.002044s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504379,614436,203592,296608,883668,153386,129955,663004,446474,330481,717440,416473,191872,1004049,229600,167237,731683,833300,400564,575524,1001653,944452,601616,383473,768745,894009,354974,523116,638222,595429,61703,603354,570240,993857,782098,498262,227002,163337,224429,352415,827649,124312,758636,972051,58165,491835,526683,82774,525794,949936,380285,660507,269435,137632,886320,652266,984635,674794,475012,330295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]