SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 115511 LIMIT 1 [ RunTime:0.000558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 115511 [ RunTime:0.002272s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (961043,40332,850894,39557,197562,585976,506221,651623,622963,1030665,451899,396812,729024,781073,1019627,772434,685747,734081,881867,259455,401772,328951,444965,228291,480304,290139,299692,869017,358982,963801,419134,680095,593929,209015,305978,197124,704150,884806,853411,329569,875702,908951,764824,161045,276356,388426,940400,300848,526356,634767,83237,460452,521569,525784,567082,397121,159712,76499,820360,573897) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 115511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 115511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]