SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 573178 LIMIT 1 [ RunTime:0.002459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 573178 [ RunTime:0.003150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542649,168409,239243,583986,660981,1045164,1031865,180768,264295,1030929,369831,523855,850674,551264,269151,189730,418385,453041,585896,843269,450244,273142,594915,650673,368377,472078,881443,366886,181777,617844,480966,1046999,363018,928599,165269,873721,36436,1027523,758543,282728,773222,457873,572163,897115,337207,954132,512618,104531,396834,690845,668042,286906,225965,607403,863572,274479,484434,1002648,752242,179645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 573178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 573178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001555s ]