SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424611 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424611 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425851,782274,72074,872430,407225,905748,192774,975648,692182,549047,851237,800651,867691,895498,764164,97050,27799,15044,45804,1039443,48243,249272,921146,247217,461458,398466,89009,495743,639574,1027015,447791,475500,558955,1007037,967923,900578,118598,201256,945828,407551,718273,137034,55186,635229,882710,355772,799613,645886,683910,665090,1017331,51024,475288,545574,103577,151997,633961,7603,1013770,1046288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]