SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535243 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535243 [ RunTime:0.002421s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830700,62454,787210,491609,389979,910116,811759,525057,841390,347765,994519,668465,813641,601115,225437,887300,813718,569303,140151,570894,308868,150671,577768,185429,158597,315513,624769,524005,225264,317202,991431,562080,218521,109661,976763,340351,796046,122832,861800,973351,894505,417952,282465,905914,735605,583805,376682,924780,1023684,815892,194056,913809,388399,134028,379176,550753,289869,452380,375928,452184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]