SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027549 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027549 [ RunTime:0.002402s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310107,1046685,218332,998013,462749,616740,289752,883313,242460,788799,525342,328691,342809,83824,295077,940395,448072,673728,576311,601079,112207,431360,876850,35582,442872,230980,293491,507313,67532,855903,942437,893299,406374,1005335,867191,360472,1014628,647360,291995,110590,670147,204865,672195,817723,168459,1047376,1023095,699093,11593,279083,177620,459269,740915,964735,339398,674964,652149,2927,1019476,86371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027549 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027549 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]