SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.012284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105407 LIMIT 1 [ RunTime:0.012476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105407 [ RunTime:0.025139s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502274,1011244,442042,876146,697467,911676,769131,696910,608779,1002853,714715,308846,96426,60763,519966,608489,970348,226965,319025,78914,219172,329092,278759,971655,237858,943352,934773,45340,155866,310141,842414,219725,165663,752373,398564,758096,685373,80853,965334,831364,621979,94784,341758,522479,307085,522307,588992,728381,847046,610128,625168,558906,441906,3052,825005,316014,147042,950296,913305,501286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.011078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003397s ]