SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101680 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101680 [ RunTime:0.003737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (208001,1014499,581186,183496,579215,896249,721655,300085,600685,972270,867502,345923,467948,188506,250471,877969,21743,726957,417497,1032077,355784,690774,109585,504140,518309,430596,1000335,180051,377856,20627,242341,219323,522909,293149,471853,999049,441295,633198,256954,629219,194288,746314,697915,187999,482705,61747,67879,452642,628060,770485,115193,370255,40469,701622,552345,355310,139939,947097,39061,234741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001331s ]