SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431882 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431882 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (167023,410360,230052,27713,477022,588844,322347,894911,419647,926470,837940,25614,550587,688949,574307,171147,705866,1003344,687949,928136,687084,281359,446168,393783,72886,247500,402111,827577,39420,338768,210517,620800,826662,638222,516241,727054,215789,881881,87434,91781,940310,359393,186474,984318,733940,380372,4360,1007463,547066,799628,31215,377470,165871,667740,631160,199351,263890,1023841,75621,5500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431882 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431882 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]