SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422544 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422544 [ RunTime:0.002045s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909758,893421,803279,911020,87973,888586,986756,81273,937973,37739,125110,872820,161912,596597,407581,563681,125074,815479,628870,318031,479131,947323,482256,53100,825951,776692,1016668,925384,776459,1047267,466514,864546,552415,624810,840567,1022893,470898,723348,725794,984942,141807,545649,595574,724018,518496,431978,623310,961651,251961,925315,209490,837776,186933,230860,991759,197617,26885,105322,851303,140978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]