SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002508s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494591 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494591 [ RunTime:0.002196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499544,950963,143820,20069,757509,1042185,200262,668521,86909,565214,192472,190466,977013,288165,145402,37213,997466,1035289,57271,232528,999431,191467,760456,600458,742586,423139,714780,283615,360301,404564,255423,863310,439761,896104,755170,322265,142220,639131,414373,356018,196261,362239,135926,27782,235186,298581,108931,145740,183693,306560,544337,67731,57203,256709,316024,384675,569227,585712,495555,617062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]