SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145809 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145809 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14512,539215,139101,754726,879477,55312,47113,775222,1043246,111660,34642,918845,323043,814562,364446,926643,973250,361070,609536,896108,769729,507727,13248,936802,354006,483951,521952,584915,889010,1021507,78909,668370,330417,42558,855084,879437,364424,913807,42744,233949,234823,124593,834561,398848,195913,249030,641130,1040378,322514,471187,45540,851125,168053,293031,999375,83294,28392,522719,630243,551259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]