SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 244530 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 244530 [ RunTime:0.002728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806711,66113,120888,162046,367528,236862,783869,680658,356544,227912,265461,700205,271228,347967,183,825669,791100,388067,516770,99524,183146,855171,704240,529118,791672,416292,35129,371889,779229,1014763,927442,715028,802653,668376,188652,47452,111822,256097,861974,338801,733227,496561,611927,768887,688771,324409,582145,38576,50295,925621,425250,145573,647092,62622,101015,606269,1022917,131208,321661,1043468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 244530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 244530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]