SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 617810 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 617810 [ RunTime:0.002196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418088,677590,879077,593098,174019,901591,497998,664577,366514,913917,867486,957144,272828,40299,822519,1025497,303319,425612,627726,21545,285849,338402,294436,625860,37226,568803,137374,793383,989525,406211,299900,740936,772910,726804,680605,136025,1021692,49347,5448,760978,41563,528461,22969,1018182,571012,129195,9353,551113,771371,558856,560649,156243,553839,728885,1043924,975200,140098,903096,436257,310572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 617810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 617810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]