SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417678 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417678 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647968,298885,844011,419153,469360,61331,781523,917533,975990,688192,1028250,591434,204086,820124,578901,175949,649741,370697,401643,812852,359375,807758,756166,637933,141000,565796,334809,444451,943431,770210,434259,369627,115021,151026,1042478,822212,302294,100695,670334,369564,825159,1006370,210307,1033480,638160,838589,267466,426077,704300,444330,322962,889622,667577,936192,163283,270087,320665,400764,714583,766252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]