SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001504s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106738 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106738 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154192,750160,867949,961590,980753,310490,2067,470697,532708,693141,807198,1022666,626527,578848,513371,208376,97954,951095,91292,135447,847137,13182,756998,241992,534915,917974,460184,343421,700381,114372,1011330,807219,423942,142848,882471,804282,792019,850539,825997,318722,193650,47235,455377,109765,688844,129964,322482,463607,679758,14890,599176,505562,161123,795837,971409,261143,520750,30318,579793,827890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106738 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000618s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106738 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]