SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403616 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403616 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930663,617254,598063,95639,304230,418853,34629,525350,429823,739168,398802,543533,366989,178067,203906,490226,485388,415217,557050,386250,643569,725232,1023593,1017921,236809,951858,14685,469563,773899,954871,924638,934807,652710,774023,713034,636863,722442,452620,326375,1047388,840342,480255,449858,577918,350450,717827,721175,1037934,792694,998955,625124,867954,804771,972126,871656,609118,287188,883008,275006,138025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]