SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331722 LIMIT 1 [ RunTime:0.000550s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331722 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (827511,476201,968158,496884,260428,5227,556208,791640,65951,469323,793758,779335,911986,348792,420557,987434,569114,489267,59907,292871,566485,598246,12608,237065,124533,483069,205752,349231,146962,417084,315477,472434,428980,819890,256048,347147,236967,118611,138163,159444,730588,284757,266873,956395,306362,624189,316042,991845,129185,1011260,873785,548910,540580,419963,161048,536482,335521,395698,989000,842891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331722 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331722 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]