SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044116 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044116 [ RunTime:0.002491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (730442,45659,261684,302369,253643,293206,565940,229413,112883,221120,784337,553133,600155,985699,103713,8375,219267,710006,1036720,999254,272967,959068,319258,485542,484300,970101,966200,533356,47562,778187,646534,43536,951964,49701,643546,770404,797172,634635,771319,900972,561209,98928,41515,919823,896198,148382,867133,535468,682633,767290,85382,222793,246441,836235,718460,256127,359366,974509,333120,799212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044116 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]