SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001427s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338308 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338308 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125796,574703,417019,7498,526498,809315,623414,879001,340093,483587,40322,210806,45866,327554,266037,725386,464961,494334,876221,268432,388791,893874,72898,218413,660006,692584,535918,507912,579897,476401,447904,288527,794531,917747,876970,631663,476331,385582,854571,928500,569629,612743,38699,943841,578714,633081,229675,727559,350925,321192,162480,840367,323858,970090,364266,1015269,496439,841747,797919,332100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]