SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001470s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450521 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450521 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796035,438093,1045045,609653,153476,727905,170483,769204,108832,638794,514534,810475,98284,194874,643522,203993,120009,1016602,913045,337081,574749,596390,313725,540041,247263,1002048,205601,672658,791378,255808,414591,394433,171210,499819,592013,462216,989410,1016106,1046735,909032,342913,455508,1043327,640745,943886,855450,170891,426081,431755,351344,647800,543727,108510,632277,73,21120,188265,782311,459929,514477) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]