SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531306 LIMIT 1 [ RunTime:0.002507s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531306 [ RunTime:0.002725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46145,828604,334439,142076,288869,1010709,452505,988760,554956,678459,296764,238354,445440,453096,786030,891274,73320,459377,937985,772465,40354,451431,970069,918413,819439,977599,789641,21670,139982,338275,329588,573787,225285,7456,321651,596461,90137,965065,792748,69797,650765,311732,602064,856289,5789,412936,299247,944607,409727,15652,576376,104790,322066,27605,1007638,282050,340480,366581,686094,818243) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]