SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35000 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35000 [ RunTime:0.001463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352579,115522,370400,230590,244907,639574,115974,1016545,539908,412977,278677,633511,920147,924309,180965,11690,874583,593793,223395,851777,895738,601384,131217,609408,667161,347824,320529,245687,349622,71886,279145,1026328,882433,90189,627115,878372,872295,68290,833894,673871,666445,468408,177547,880732,149907,500332,885116,1021271,211171,541424,904648,374812,317950,746182,963469,151754,804419,51225,544748,89454) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35000 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35000 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]