SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348897 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348897 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508348,271352,366451,929474,687750,157075,214238,924064,294629,614767,220300,944921,451985,50080,53423,989985,671743,228700,207978,967165,157274,298097,255949,198375,84144,75931,119324,382071,932032,416788,585138,118255,427707,235695,810023,158104,480705,3920,387422,430270,431203,241202,794350,425031,961560,238676,170683,957734,88786,701538,71401,565461,441756,373100,169546,63525,767827,821578,124742,273710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]