SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553458 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553458 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527156,868030,297,105947,1045772,774184,220902,477753,384619,124623,610519,445652,48138,151572,833400,383411,254032,389248,887030,195713,501889,738217,536242,33132,757371,798301,101377,498955,592976,307814,991749,427408,363523,158878,1019143,269698,694215,864373,209063,317841,392196,383400,675799,757737,424230,255734,674864,161246,591277,947546,400572,655679,733125,627889,814003,12766,361090,945096,260686,653163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]