SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471017 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471017 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125689,576462,889959,338460,154412,517457,686018,121897,268162,201374,70330,770554,461260,542114,655512,322992,395933,709656,1004374,800481,178548,895315,404179,401192,463146,974952,651118,445734,194450,12284,349814,451422,572332,18563,433798,172761,516569,961516,365036,679929,146760,432496,368193,950731,75188,581138,685764,949775,803513,990680,878768,247616,586881,821246,689701,629159,121946,462113,191517,648479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]