SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001613s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505246 LIMIT 1 [ RunTime:0.001502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505246 [ RunTime:0.005123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50688,567566,880543,499411,868868,788872,163704,125770,356865,1012221,351425,757200,977894,465432,677240,444264,8953,326484,408473,697501,239045,349013,924805,705145,278693,748178,814680,518176,892744,284139,352027,246791,688034,27524,327215,407397,875434,30065,345100,646443,576114,226923,373160,662203,373629,62673,810988,38526,14849,118106,658912,321278,114012,596198,745217,841526,426775,220149,692768,171532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000739s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002496s ]