SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017343 LIMIT 1 [ RunTime:0.000603s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017343 [ RunTime:0.002116s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104689,789069,214469,29092,137642,488367,96307,1021186,757522,511732,222885,80867,599354,900630,879847,785557,421735,884183,77487,435075,788011,594146,403160,794519,92579,1003297,208290,6647,249610,397925,775724,169512,137904,103857,964164,861517,834124,4571,666369,579814,196726,6629,877894,742017,16276,63648,597392,874248,245727,289597,188737,911447,451346,223987,14882,639056,8664,648191,593836,349826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]