SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509509 LIMIT 1 [ RunTime:0.001099s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509509 [ RunTime:0.002229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506970,489396,787063,747216,757583,354177,508761,755838,92546,864373,781192,284710,601194,625914,594868,309206,548308,740492,326185,271852,770828,417563,458627,906902,647434,394004,983090,773014,980938,530236,271583,555473,92998,897020,989475,914535,147682,508510,8029,116862,633766,68764,754714,720948,209003,437649,220649,803837,255372,906802,334087,677390,209899,459728,205783,333787,770451,813028,213907,254982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016891s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001748s ]