SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001988s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586364 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586364 [ RunTime:0.005144s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385605,371545,136708,320617,437813,433642,776900,912668,817693,558443,822667,727805,706682,682743,236060,577813,968721,886894,746998,15603,455493,1044103,790460,55732,697807,1032660,530736,385244,855135,567987,414263,217219,480138,696595,445178,619636,869076,121110,525112,973519,768670,546856,790502,514760,414149,597151,404877,11584,194651,115460,1041560,747482,321102,741543,582251,945182,766601,827269,51680,277263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.019879s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586364 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586364 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000968s ]