SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681671 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681671 [ RunTime:0.002465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027011,201654,593395,12221,1026638,944671,715371,290651,786749,438067,401455,998241,1426,734169,867842,692458,298071,102922,733835,572744,324901,575047,16892,720195,587768,513297,194141,841262,676306,726263,279574,546749,506470,642622,709521,1045112,399474,1021898,359165,884651,865808,522395,394044,1041434,723357,512467,72440,71492,528537,335052,802048,433412,575325,593305,321725,245557,407497,698766,927226,812959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]