SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563354 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563354 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284823,718913,588838,561679,192514,312742,637508,958484,24030,482393,615385,760539,652882,340427,847825,770238,549773,497097,306664,586930,721651,95082,534851,823729,769090,537589,393166,497580,165616,141994,675810,733097,4209,205925,529194,644407,859391,92339,820714,459932,489271,147099,607270,757414,819924,1023551,828457,589250,850622,324300,654668,725914,618831,731984,445129,974504,364122,1015566,580314,978701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]