SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 631001 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 631001 [ RunTime:0.002467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444209,72884,254875,91210,904163,1016858,85317,1011593,838957,747555,1046842,442072,49168,628419,735623,959317,864203,513312,809991,379014,666307,700172,722223,663130,36159,916622,662890,203660,373135,995151,434432,879245,779307,253797,376669,496958,218867,511138,883935,327774,510303,810388,315432,643754,337654,143679,780525,555157,55772,420686,760540,1021912,291259,322791,515544,787941,499002,565322,643687,824317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 631001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000844s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 631001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]