SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509748 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509748 [ RunTime:0.001566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (969707,706291,974502,60937,835500,115196,265367,218816,858285,192777,499604,221167,889380,123248,190921,956860,491220,896658,725534,204158,409682,384308,833773,393967,426011,973339,187173,843451,572031,353774,677630,788221,96734,126295,763435,697216,769002,132120,484412,914970,846110,27176,917015,120410,85280,920035,23920,375045,750784,760184,302157,685448,261296,827021,389699,145346,713712,918926,484253,56002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]