SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417548 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417548 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344796,883113,524422,262895,761801,186738,791651,83994,1020249,17940,806631,894906,824188,4573,506696,281228,469774,549525,643085,436576,532039,591477,939600,563274,1036503,928027,928105,155701,580778,592170,198724,668291,269238,544500,933468,780064,381572,209862,694985,429567,964630,78434,37881,517281,102302,529894,22124,812111,124439,475389,137151,543755,1005043,951341,169282,916227,637076,385924,23549,731888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417548 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417548 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]