SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031197 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031197 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113895,209323,619314,402593,776537,243922,411512,223659,230948,217504,446304,836231,943023,849516,172441,957755,842651,725245,951848,867126,112816,903463,10089,350623,214290,770328,402714,424524,471523,497038,590755,646660,201077,1003060,410492,376402,547364,217282,877250,447447,171243,621359,789220,589154,307615,536487,783071,659345,277705,776892,696243,1046917,1015274,10039,182123,469147,518233,701460,139567,909705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002402s ]